<?php
header('content-type:text/html;charset=utf-8');
$link=mysqli_connect('localhost','root','');
if (!$link){
    die('连接数据库失败!'.mysqli_error($link));
}

$fields=array('e_dept','date_of_entry');
$sql_order='';
$order=isset($_GET['order']) ? $_GET['order']:'';
$sort=isset($_GET['sort']) ? $_GET['sort']:'';
if (in_array($order,$fields)){
    if($sort=='desc'){
        $sql_order="order by $order desc";
        $sort='asc';
    }else{
        $sql_order="order by $order asc";
        $sort='asc';
    }
}

mysqli_query($link,'set names utf8');
mysqli_query($link,'use `itcast`');
$sql="select* from `emp_info` $sql_order";
$res=mysqli_query($link,$sql);
$emp_info=array();
while($row=mysqli_fetch_assoc($res)){
    $emp_info[]=$row;
}
define('APP','itcast');
require './list_html(12).php';